◀ Prev · Parts · Full · Next ▶

IBM DB2 version 10 claims to be the first database to have a conforming implementation of this feature in what they call "Time Travel Queries",cite-ref-7[7]cite-ref-8[8] although they use the alternative syntax FOR SYSTEM_TIME AS OF.

Oracle 12c supports temporal functionality in compliance with SQL:2011.cite-ref-9[9] Versions 9,cite-ref-10[10]cite-ref-11[11] 10g and 11g implement the time-sliced queries in what they call Flashback Queries, using the alternative syntax AS OF TIMESTAMP.cite-ref-12[12] Notably both of Oracle's implementations depend on the database's rollback segment and so only allow temporal queries against recent changes which are still being retained for backup.

Microsoft SQL Server (version 2016) implements temporal tables with SYSTEM_VERSIONING.cite-ref-13[13]

MariaDB 10.3 implements system-versioned tables.cite-ref-14[14] MariaDB 10.4.3 added support for application-versioned tables.cite-ref-15[15]

PostgreSQL requires installation of the temporal_tables extension. Temporal Tables Extension supports the system-period temporal tables only, but does not follow the SQL:2011 design.

◀ Prev · Parts · Full · Next ▶